Introduction to Tableau Worksheets

Course: Tableau Data Visualization and Business Intelligence

Topic: Introduction to Tableau Worksheets

Course Link: JustAcademy Tableau Training

Demo Link: Register for a Tableau Course Demo

1. Introduction to Tableau Worksheets

A Tableau worksheet is the primary workspace where you create an individual data visualization. It allows you to explore data, compare values, identify trends, and present information through charts, tables, maps, and other visual formats.

In Tableau, you build a visualization by dragging fields from the Data pane onto shelves and cards, such as Rows, Columns, Filters, and the Marks card. Tableau uses these fields to construct a view based on the data and the selected configuration.

For example, if a company wants to analyze sales by region, you can create a worksheet by placing Region on Rows and Sales on Columns. Tableau can then generate a chart showing how sales differ across regions.

A worksheet generally contains one view. A workbook can contain multiple worksheets, and those worksheets can be combined into dashboards or used in stories.

Official Tableau reference: Workbooks and Sheets.

2. Learning Objectives

After studying this topic, you will be able to:

• Understand what a Tableau worksheet is.
• Explain the difference between a workbook, worksheet, dashboard, and story.
• Identify the main components of the Tableau worksheet interface.
• Understand dimensions and measures.
• Use Rows and Columns shelves to build a view.
• Customize visualizations using the Marks card.
• Filter, sort, and format data in a worksheet.
• Create basic charts using Tableau fields.
• Rename, duplicate, and organize worksheets.
• Build a simple sales analysis worksheet using a sample dataset.

3. What Is a Tableau Worksheet?

A Tableau worksheet is an individual sheet used to create and analyze a visualization. It provides a canvas where you can place data fields and configure how information is displayed.

Worksheets can be used to create:

• Bar charts to compare categories.
• Line charts to analyze trends over time.
• Pie charts to show proportions when appropriate.
• Text tables to display detailed records or summary values.
• Scatter plots to examine relationships between numerical variables.
• Maps to analyze geographical data.
• Highlight tables to compare values using colour.
• Other supported visualizations based on the data and selected fields.

Example

Suppose a retail company has the following sales data:

Using this data, you can create a worksheet that compares Sales by Region or displays Profit by Category. You can also add filters to examine selected regions or categories.

4. Understanding Workbook, Worksheet, Dashboard, and Story

These are important concepts in Tableau. Although they are related, they serve different purposes.

Relationship Between These Components

Tableau Workbook
├── Worksheet 1: Sales by Region
├── Worksheet 2: Profit by Category
├── Worksheet 3: Monthly Sales Trend
├── Dashboard: Sales Overview
└── Story: Business Performance Analysis

Key point: A worksheet is typically used to build an individual view. A dashboard combines multiple views, while a story presents a sequence of views or dashboards to communicate an analytical message.

5. Opening and Creating a Worksheet

5.1 Open Tableau

Launch Tableau Desktop or an appropriate Tableau authoring environment. Connect to a data source, such as an Excel file, text file, database, or Sample - Superstore dataset.

5.2 Open a Worksheet

After connecting to the data source, open an existing worksheet or select the new worksheet icon at the bottom of the workbook. Tableau commonly creates an initial worksheet named Sheet 1.

5.3 Create a New Worksheet

1. Open your Tableau workbook.
2. Locate the sheet tabs at the bottom of the workspace.
3. Click the New Worksheet icon.
4. Wait for the blank worksheet to open.
5. Locate the fields in the Data pane.
6. Drag fields onto Rows, Columns, or other shelves and cards to build your view.

5.4 Rename the Worksheet

1. Locate the worksheet tab.
2. Double-click the sheet name or use its context menu.
3. Enter a descriptive name.
4. Press Enter to confirm.

Examples of useful worksheet names include Sales by Region, Monthly Revenue Trend, Profit Analysis, and Customer Overview.

6. Understanding the Tableau Worksheet Interface

The Tableau worksheet workspace contains several components that work together to create visualizations.

Some cards, legends, and controls appear only when required by the view. For example, a colour legend normally appears when a field is used on Colour.

Official reference: The Tableau Workspace.

7. Understanding the Data Pane

The Data pane contains the fields available from your connected data source. These fields are the main building blocks used to create a visualization.

7.1 Dimensions

Dimensions are fields used to describe, categorize, or group data. They are commonly used to split data into categories.

Examples: Region, Category, Customer Name, Country, and Order ID.

If you place Region on Rows, Tableau can display a separate row for each region represented in the view.

7.2 Measures

Measures are fields containing values that can be measured or summarized. Tableau commonly aggregates measures when they are added to a view.

Examples: Sales, Profit, Quantity, and Discount.

If you place Sales on Columns, Tableau can display a quantitative axis based on the aggregation applied to Sales.

7.3 Dimensions vs. Measures

A field's role and behaviour depend on its data type, configuration, and how it is used in the worksheet.

8. Rows and Columns Shelves

The Rows and Columns shelves determine the main structure of a visualization. Fields placed on these shelves influence how data is arranged in the view.

8.1 Rows Shelf

The Rows shelf generally creates rows or vertical-axis elements. Placing a dimension on Rows often creates row headers for its members. Placing a measure on Rows commonly creates a vertical quantitative axis.

Example: Drag Region to Rows to show regional categories in the worksheet.

8.2 Columns Shelf

The Columns shelf generally creates columns or horizontal-axis elements. Placing a dimension on Columns often creates column headers. Placing a measure on Columns commonly creates a horizontal quantitative axis.

Example: Drag Sales to Columns to compare sales across regions.

8.3 Creating a Basic Bar Chart

1. Open a new worksheet.
2. Drag Region to Rows.
3. Drag Sales to Columns.
4. Check that Tableau displays a bar chart or select a suitable bar chart through Show Me.
5. Review the sales values and category labels.
6. Rename the worksheet Sales by Region.

The resulting view compares sales across the available regions. Tableau's default aggregation and mark type can depend on the fields and current settings.

9. Understanding the Marks Card

The Marks card controls how Tableau represents data points or marks in a visualization. A mark may be a bar, line, circle, square, text label, or another visual representation.

Common Marks card properties include:

Example: Add Colour to a Bar Chart

1. Create a bar chart using Region and Sales.
2. Drag Region to Colour on the Marks card.
3. Observe how the bars are coloured according to region.
4. Check the colour legend to understand the category-to-colour mapping.

Example: Add Sales Labels

1. Use the same bar chart.
2. Drag Sales to Label on the Marks card, or enable mark labels through the Label option.
3. Review the displayed values.
4. Adjust the label formatting if necessary.

Official reference: Shelves and Cards Reference.

10. Using the Filters Shelf

The Filters shelf allows you to include or exclude data from a worksheet based on selected conditions. Filters help users focus on the records relevant to a particular question.

Example: Filter Sales by Region

1. Create a chart using Region and Sales.
2. Drag Region to the Filters shelf.
3. Select the regions you want to include.
4. Confirm the selection.
5. Review the updated visualization.

Example: Filter by Order Date

1. Drag Order Date to Filters.
2. Choose the appropriate date-filter option.
3. Select a date range or period.
4. Apply the filter and review the view.

Filters can be used to limit data by category, date, numerical range, or other supported conditions. A worksheet filter and a visible filter control are related but different: you may choose to display a filter control so users can interact with it.

11. Using the Pages Shelf

The Pages shelf allows you to break a view into separate pages based on a field. It is useful for examining how the same visualization changes across values such as year or month.

Example: View Sales by Year

1. Create a sales visualization.
2. Drag Order Date to the Pages shelf.
3. Select a suitable date level, such as Year.
4. Use the page controls to move through the available values.
5. Observe how the view changes from one year to another.

The Pages shelf is different from a normal filter. A filter selects which values are included, while Pages provides a way to navigate through the view one value or page at a time.

12. Creating Different Visualizations in a Worksheet

Tableau worksheets can be used to create different visualizations depending on the fields and the analytical question.

Using Show Me

Show Me recommends visualization types based on the fields selected in the Data pane. It is useful when you are learning Tableau or want to explore possible chart types.

1. Select one or more relevant fields in the Data pane.
2. Open Show Me.
3. Review the available chart types.
4. Select a suitable visualization.
5. Review the result and make any necessary adjustments.

Always choose a chart based on the question you need to answer rather than selecting a chart only because it is available.

13. Sorting Data in a Worksheet

Sorting arranges categories or values in a meaningful order. It helps users identify the highest, lowest, earliest, latest, or otherwise relevant results.

Common Sorting Options

Example: Sort Regions by Sales

1. Create a bar chart using Region and Sales.
2. Select the Region header or relevant sort control.
3. Choose descending sort or configure sorting by Sales.
4. Verify that the regions appear in the intended order.

14. Formatting a Worksheet

Formatting improves the readability and presentation of a visualization. It can include changing titles, fonts, number formats, gridlines, shading, alignment, and labels.

14.1 Change the Worksheet Title

1. Locate the worksheet title above the view.
2. Double-click the title or use the available title-editing option.
3. Enter a meaningful title, such as Regional Sales Performance.
4. Confirm the change.

14.2 Format Numbers

Use appropriate number formats for the data being displayed. For example, Sales may be displayed as currency, while a conversion rate may be displayed as a percentage. Formatting should accurately reflect the underlying values.

14.3 Improve Readability

• Use descriptive titles.
• Keep labels readable.
• Avoid unnecessary gridlines and decorative elements.
• Use consistent colours and number formats.
• Ensure axes and units are clear.
• Use tooltips to provide supporting details without overcrowding the view.

Official reference: Format at the Worksheet Level.

15. Managing Worksheets

As a Tableau project grows, it may contain many worksheets. Organizing them helps users navigate the workbook and understand the purpose of each view.

15.1 Rename a Worksheet

Rename a worksheet to describe the analysis it contains. Examples include Sales by Category, Profit by Region, and Monthly Sales Trend.

15.2 Duplicate a Worksheet

Duplicating a worksheet is useful when you want to create a similar view while preserving the original. Use the sheet tab's context menu to select the duplicate option available in your Tableau environment.

15.3 Create Multiple Worksheets

Use separate worksheets for different analytical questions. For example, one worksheet can show sales by region, another can show profit by category, and a third can show monthly trends.

15.4 Delete a Worksheet

If a worksheet is no longer needed, use its context menu to delete it. Check whether the sheet is used by a dashboard or story before removing it.

15.5 Organize Sheet Names

• Use meaningful names instead of leaving every worksheet as Sheet 1, Sheet 2, or Sheet 3.
• Use a consistent naming style.
• Group related analysis conceptually through sheet names.
• Keep the workbook easy to navigate for other users.

16. Practical Project: Create a Sales Analysis Worksheet

Project Goal: Build a worksheet that compares sales by region and allows users to explore the results.

Dataset Requirements

Use Sample - Superstore or another sales dataset with fields such as Region, Category, Order Date, Sales, and Profit.

Step 1: Connect to the Dataset

Open Tableau and connect to your sales dataset. Open a new worksheet.

Step 2: Build a Bar Chart

1. Drag Region to Rows.
2. Drag Sales to Columns.
3. Check that a suitable bar chart appears.
4. Rename the worksheet Sales by Region.

Step 3: Sort the Results

Sort the regions by sales in descending order so that the highest-sales region appears first.

Step 4: Add Colour

Drag Region to Colour on the Marks card. Choose a readable colour scheme and check the legend.

Step 5: Add Labels

Enable mark labels or drag Sales to Label to show the values directly on the bars.

Step 6: Add a Filter

Drag Category to Filters and select the categories you want to include. If appropriate, show a filter control so users can change the selection.

Step 7: Add a Tooltip

Configure the tooltip to show useful information such as Region, Sales, and Profit when a user hovers over a mark.

Step 8: Review and Save

• Check the worksheet title.
• Confirm that the chart is easy to read.
• Verify that the filter works correctly.
• Confirm that the sales values use the correct aggregation and number format.
• Save the workbook.

Expected Result

You should have a worksheet that compares sales across regions, shows sales values, and allows users to focus on selected product categories. This worksheet can later be added to a dashboard.

17. Advantages of Tableau Worksheets

• Interactive analysis: Build and explore views by changing fields, filters, and marks.
• Flexible visualization: Create charts, maps, tables, and other supported views.
• Quick exploration: Rearrange fields to investigate different business questions.
• Data comparison: Compare values across categories and time periods.
• Detailed analysis: Use filters, labels, and tooltips to explore specific information.
• Reusable work: Combine worksheets into dashboards or stories.
• Clear communication: Use titles, formatting, and visual encoding to communicate findings.

18. Common Mistakes and Solutions

19. Best Practices for Tableau Worksheets

1. Start with a clear business question.
2. Choose the fields needed to answer that question.
3. Use dimensions to categorize data and measures to analyze values.
4. Place fields on Rows and Columns to establish the view's structure.
5. Use the Marks card to add meaningful visual detail.
6. Apply filters when you need to focus on specific data.
7. Choose a suitable chart type.
8. Use readable titles, labels, and number formats.
9. Check aggregations and calculations before interpreting results.
10. Rename worksheets so they are easy to identify.
11. Keep worksheets focused and avoid unnecessary visual elements.
12. Review the view before using it in a dashboard or story.

20. Interview Questions and Answers

Q1. What is a worksheet in Tableau?

Answer: A worksheet is an individual sheet where users create and analyze a visualization by placing data fields on shelves and cards.

Q2. What is the difference between a workbook and a worksheet?

Answer: A workbook is the overall Tableau file, while a worksheet is an individual sheet within that workbook.

Q3. What is the difference between a worksheet and a dashboard?

Answer: A worksheet typically contains an individual view. A dashboard combines multiple views and other supported objects into a single presentation.

Q4. What is the purpose of the Data pane?

Answer: The Data pane displays the fields available from the connected data source, including dimensions, measures, and calculated fields.

Q5. What are Rows and Columns shelves used for?

Answer: They define the structure of the view. Dimensions often create headers, while measures commonly create quantitative axes.

Q6. What is the Marks card?

Answer: The Marks card controls the visual appearance of marks using properties such as Colour, Size, Label, Detail, Tooltip, and Shape.

Q7. What is the Filters shelf used for?

Answer: It restricts the data included in a view according to selected conditions.

Q8. What is the Pages shelf?

Answer: It lets users navigate through a view page by page according to the values of a field.

Q9. How do you create a bar chart in Tableau?

Answer: Place a categorical dimension on Rows and a measure on Columns, then select an appropriate bar chart if Tableau does not choose one automatically.

Q10. How can you rename a worksheet?

Answer: Double-click the worksheet tab or use its context menu, enter the new name, and confirm it.

Q11. What is Show Me?

Answer: Show Me recommends visualization types based on the selected fields and their characteristics.

Q12. Can one workbook contain multiple worksheets?

Answer: Yes. A workbook can contain multiple worksheets as well as dashboards and stories.

Q13. Why are tooltips useful?

Answer: Tooltips display additional information when a user hovers over a mark, providing context without adding too much text to the visualization.

Q14. What should you check before finalizing a worksheet?

Answer: Check the chart type, aggregation, filters, labels, title, number formatting, and accuracy of the underlying data.

21. Practical Exercises

Exercise 1: Create a Basic Worksheet

Connect to Sample - Superstore and create a bar chart showing Sales by Region. Rename the worksheet Sales by Region.

Exercise 2: Create a Monthly Trend

Use Order Date and Sales to create a line chart that shows how sales change over time.

Exercise 3: Add a Filter

Add Category to the Filters shelf and explore how the chart changes when you select different categories.

Exercise 4: Customize Marks

Add colour and labels to a bar chart. Use tooltips to display additional information when hovering over the marks.

Exercise 5: Create a Text Table

Build a text table showing Category, Sales, and Profit. Format the numerical values so they are easy to interpret.

Exercise 6: Organize Worksheets

Create three worksheets named Sales by Region, Profit by Category, and Monthly Sales Trend. Arrange the sheet tabs in a logical order.

Exercise 7: Explore Show Me

Select different combinations of dimensions and measures, open Show Me, and compare the recommended visualization types.

22. Quick Revision Notes

• A worksheet is where an individual visualization is created.
• A workbook can contain worksheets, dashboards, and stories.
• The Data pane contains fields from the connected data source.
• Dimensions commonly categorize data.
• Measures commonly contain values that can be aggregated.
• Rows and Columns shelves define the structure of a view.
• The Marks card controls visual properties such as colour, size, labels, and tooltips.
• The Filters shelf restricts which data appears in a view.
• The Pages shelf supports page-by-page exploration.
• Show Me recommends chart types based on selected fields.
• Sorting helps arrange categories or values in a meaningful order.
• Clear titles and readable formatting improve worksheet usability.
• Worksheets can be combined into dashboards or used in stories.

23. Final Checklist

• Connect to the correct data source.
• Identify the required dimensions and measures.
• Create a worksheet for the business question.
• Place fields on the appropriate shelves.
• Choose a suitable visualization type.
• Configure marks, colours, labels, and tooltips where necessary.
• Apply filters and sorting correctly.
• Check aggregation and numerical formatting.
• Give the worksheet a meaningful name and title.
• Verify the results and save the workbook.

24. Conclusion

Tableau worksheets are the foundation of data visualization in Tableau. They allow users to create individual views by combining dimensions, measures, shelves, cards, filters, and formatting options. By learning how to build and manage worksheets, you can analyze business data, identify patterns, and prepare views for dashboards and stories.

Start with simple worksheets such as Sales by Region or Profit by Category. As you gain experience, explore filters, time-based trends, tooltips, and more advanced visualizations. Always ensure that the view answers a clear question and presents data accurately.

Explore the course: JustAcademy Tableau Training

Register for a demo: Register for a Tableau Course Demo